Sales By Category Sheet 18



1. Right click on Sales by day sheet and select Duplicate. Rename the new sheet as Sales by Category.


Remove all the values from Columns shelf, Rows shelf and under Marks.

2. Drag and drop Sales MoM% to Columns shelf and Quantity to Rows shelf.

3. Drag and drop Pizza Category to Color under Marks.

 Click on Color > Edit Colors

 Chicken - #e15759

 Classic - #f28e2b

 Supreme - # 9c755f

 Veggie - #59a14f

4. Drag and drop Pizza Name to Label under Marks.

5. Drag and drop Pizza Name to Detail under Marks.

6. Drag and drop Total Price to Size under Marks. Click on Show Me and select Scatter Plot chart type.

7. Change the type of chart under Marks to Circle.

8. Right click on Y axis and select Edit axis. Under Range, select Fixed.

 Fixed Start = 0, Fixed End = 4800

Under Axis Titles, Title = Total Orders

Right Click on Y axis, select Format. Under Axis pane, Title – Font = Tableau Medium, Size=9, Bold, Color = #ff7400

9. Right Click on X axis, select Format. Under Axis pane, Title – Font = Tableau Medium, Size=9, Bold, Color = #6b3b00

10. Click on Tooltip under marks and enter the following:

Pizza Category: <Pizza Category>

 Pizza Name: <Pizza Name>

 Total Sales: <SUM(Total Price)>

 Sales MoM: <AGG(Sales MoM %)>

 Total Orders: <SUM(Quantity)>

 Avg Orders:<AGG(Avg Orders By Day)>

 Orders MoM:<AGG(Orders MoM %)>

 Avg Price:<AGG(Avg Order Price)>

 Avg Price MoM:<AGG(Avg Price MoM %)>

7. Right click on Title, select Edit Title, add the title Sales by Category.


Follow the Gif files below for step by step instructions:




How to create a Scatter plot in Tableau